UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '93psihZQcwytjxSbWl+lKGiuoD5c6BgTlOyG6IYqx20='
WHERE
key_id = '847551b79fed3c90be1a7a967d77f271169bc700ca3d452c5f10437b7bc916c1'
AND (
token = '93psihZQcwytjxSbWl+lKGiuoD5c6BgTlOyG6IYqx20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)