UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xd7AW10+ES9N/bv9tiMPEUMIbnkz11CSgEuZkSid79A='
WHERE
key_id = 'fae7481b8d5d3ae9ff70ff3304f7d7fb0b444bd0e9312223cf20ba84d4b3f1a8'
AND (
token = 'xd7AW10+ES9N/bv9tiMPEUMIbnkz11CSgEuZkSid79A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)