UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qLTKn0+MxhGkrxS6FrEcZNkxDQ0bK+e1n623HUFf+TA='
WHERE
key_id = 'f4adcc6c8a716acaa019c28ed8b5c00e869f50a0398e0421d09076131c00842a'
AND (
token = 'qLTKn0+MxhGkrxS6FrEcZNkxDQ0bK+e1n623HUFf+TA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)