UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hp4CiYMqELkSFf90qciMakvPcaKnp1CJuF8U4AMXHMo='
WHERE
key_id = '964d2695f20fdf2884e1576bfd8861c64e0db2391218e317c96fe114c3f6d0b8'
AND (
token = 'hp4CiYMqELkSFf90qciMakvPcaKnp1CJuF8U4AMXHMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)