UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5nSQ9meiaz1C5mPniAqzZE3bdpqTk80h6Sbe9oPfPBg='
WHERE
key_id = '1699ea764e5c6fe4d08e52e7617630469debab281274efff6781a642949f7539'
AND (
token = '5nSQ9meiaz1C5mPniAqzZE3bdpqTk80h6Sbe9oPfPBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)