UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qj3TNVHpB6GiPqS/CKhWNQZwrEnKFIO7yjLnhYOAi00='
WHERE
key_id = 'd299dd6f51c725dd619529bffd90ad288e23a01e0659832bbef4ccaf9a7d6537'
AND (
token = 'qj3TNVHpB6GiPqS/CKhWNQZwrEnKFIO7yjLnhYOAi00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)