UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c1ztE633YjlpGdnK6ZFk4tv/WHROpIAeM6sI6pvzNqM='
WHERE
key_id = 'a0b2c6098efb1077c9bbaad620839f055852aef09e0a555ca3837406b16d5dea'
AND (
token = 'c1ztE633YjlpGdnK6ZFk4tv/WHROpIAeM6sI6pvzNqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)