UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qpeXNxs1XNA5VV6kSv+RugBLoWgDXvs2mygos7sfvcI='
WHERE
key_id = 'a1a3975a4cb449fd82f49277dd070845cd80339c5dea468806c437d60c490dae'
AND (
token = 'qpeXNxs1XNA5VV6kSv+RugBLoWgDXvs2mygos7sfvcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)