UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vgGEEeX0LquKE+z0SuI8mECWc0mTGgWVivw1w2G4eEk='
WHERE
key_id = '0c6a8593694c31efbb6c8f271766449c415ae606d37f2a2efab0f78c38ec7e22'
AND (
token = 'vgGEEeX0LquKE+z0SuI8mECWc0mTGgWVivw1w2G4eEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)