UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YBzsvizhVlOghIg9jCuDLWaSOoMXPEYj4P0PZDuvof0='
WHERE
key_id = '05ae2c4c5a2bd931b7cfb447f17d4dbe27e036bce38d4f9c10bec22e7d7bdd30'
AND (
token = 'YBzsvizhVlOghIg9jCuDLWaSOoMXPEYj4P0PZDuvof0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)