UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y7/J5j4QLOVlAtZyz97iznEGeFa4Cz0VQv0gY9lNGu8='
WHERE
key_id = '00be7df50a481719a05cf4ad0b09d27450850bfb379c4843a437b07de0e81085'
AND (
token = 'y7/J5j4QLOVlAtZyz97iznEGeFa4Cz0VQv0gY9lNGu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)