UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bsf4tz6KVoBPJTsgR8zUu1gnHMnqJknFxtOJZM8TT18='
WHERE
key_id = '784372f7e123b80586e94929a2e4895cbd5baf1ed2b3c4244989be5e689e3eb9'
AND (
token = 'bsf4tz6KVoBPJTsgR8zUu1gnHMnqJknFxtOJZM8TT18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)