UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrI1V8C6EsBOcoy6XTWSMkcfHywTMX3xVmJFP/OiUQU='
WHERE
key_id = 'beb20b531aeaf022ba37666f2a0b15420264e5cafb839311544c20023d038644'
AND (
token = 'ZrI1V8C6EsBOcoy6XTWSMkcfHywTMX3xVmJFP/OiUQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)