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