UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TAupehP363OCY4jI4tqlxtvcD0n2aPYfzclzSbqX5x4='
WHERE
key_id = '254aa10ae1fbb59842919d5ca5521816df0af209dba13497cfeb5fc760a933fe'
AND (
token = 'TAupehP363OCY4jI4tqlxtvcD0n2aPYfzclzSbqX5x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)