UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8LMKl+o6UEmhx91noKNC1lSzROTFHxLQuC9fC9WazU='
WHERE
key_id = '6b10bbb5342913197880665e262032a70e1d9fc0a3238ddecaa2d208d6e96239'
AND (
token = 'q8LMKl+o6UEmhx91noKNC1lSzROTFHxLQuC9fC9WazU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)