UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXI4PDSujM0vkujJ5acDJmbHJh/DcXOwM6845Y61uMc='
WHERE
key_id = 'e263971cb3c59b7ab342bcd8f9bb11487233e418ec45dd5690035c27a64554e5'
AND (
token = 'WXI4PDSujM0vkujJ5acDJmbHJh/DcXOwM6845Y61uMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)