UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sx9edxrRirnzzR496zcsKO8j3/muxs5UB862qxv8Mw4='
WHERE
key_id = 'fca5bc72c89d61b918abd1dad6b8d1ab86b0a05c08d5b4ef0d7e30c49b8ef360'
AND (
token = 'Sx9edxrRirnzzR496zcsKO8j3/muxs5UB862qxv8Mw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)