UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qW93zvfLL5E0cJWhYZ56RgAvxv0WCcTNZQnHdghjWk='
WHERE
key_id = '8cd30483e50ecc63bceb799e65f1453df5774ec872883916b52c7cf047fa0c37'
AND (
token = '8qW93zvfLL5E0cJWhYZ56RgAvxv0WCcTNZQnHdghjWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)