UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H6SnpCPx+AIiX98CD+/x0DS4k7Ml9VZzlC6XXUVmmyA='
WHERE
key_id = 'dfd78f58b4669d7f4230e5dcd7dcaef41aa9ff0c224119b546e626729c1834b8'
AND (
token = 'H6SnpCPx+AIiX98CD+/x0DS4k7Ml9VZzlC6XXUVmmyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)