UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/7139I1HCxAqgGFMp0RYZkKLbYWEGUJA5dQZfqvDno='
WHERE
key_id = '24225bcea1f451a55468c86e5921b4fa955ed2812b6daf0377187298342bfeec'
AND (
token = 'N/7139I1HCxAqgGFMp0RYZkKLbYWEGUJA5dQZfqvDno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)