UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jgsucKXnkWSDPTii6J3s2PcYkngNM9uSpJQK6DyCnrc='
WHERE
key_id = '9418304e519a990232b835fbf359bd4ba81aa0a4c6f51ac36358389b61ba5318'
AND (
token = 'jgsucKXnkWSDPTii6J3s2PcYkngNM9uSpJQK6DyCnrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)