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