UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r1+ZQuGElqT8NJkIQjvJQBKUpvoz7SKvaFew/r9zPgo='
WHERE
key_id = '9200728d5d82d9fff6084156a2a7012a9ffc7ec14df0a9489a2bcaa1fd5445e8'
AND (
token = 'r1+ZQuGElqT8NJkIQjvJQBKUpvoz7SKvaFew/r9zPgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)