UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qvo8PH6ldd52u4ICgaBKIaQ9p6DcklW3qlSe4nreOgU='
WHERE
key_id = 'e0bc8aceeb852070bccc1e357d37aad61eac9f48ae3b914a26a49233a6f437f8'
AND (
token = 'qvo8PH6ldd52u4ICgaBKIaQ9p6DcklW3qlSe4nreOgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)