UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xOgS+s2PaXqZFfK27Jsqv6KAsA3PLs1SoVgX+NLoDgQ='
WHERE
key_id = 'd9581afc6e3ffc76f6cf1fb1d7c4947e0e21dfeb42f48a99ba507bb07bc2b8b2'
AND (
token = 'xOgS+s2PaXqZFfK27Jsqv6KAsA3PLs1SoVgX+NLoDgQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)