UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xwADSRzwk8XKHXDBZxf9tv+p5SLp+1A7MzqNu9dJ33s='
WHERE
key_id = '3c9ba4827e302c29eda0a17fa84544cbb77978484e2e91fe91357acc34694fb4'
AND (
token = 'xwADSRzwk8XKHXDBZxf9tv+p5SLp+1A7MzqNu9dJ33s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)