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