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