UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UuihaObA60dKQcheQIflOL1OG/joE4IcnusiawdTnl4='
WHERE
key_id = '8d0873d4252667658f689a27b788fd2e91cde492740222ff8fbb94abfe195867'
AND (
token = 'UuihaObA60dKQcheQIflOL1OG/joE4IcnusiawdTnl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)