UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'be5zGeKfYT6ocfL1q9OD5GwuCGenDq8tMaZ3ncGrRYg='
WHERE
key_id = 'c944fe9f5db54346259bb987967ff143545e702958cc54edd1f1daf7c653392a'
AND (
token = 'be5zGeKfYT6ocfL1q9OD5GwuCGenDq8tMaZ3ncGrRYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)