UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bYV/pAj5asXbJWIavXTj5J25z2O2HrG+AP0Ku7Voeno=' 
WHERE 
  key_id = 'b523acd2f1da67cd3d876e9a6c89ba54de435d5c5e425795c8c218f36e46ba88' 
  AND (
    token = 'bYV/pAj5asXbJWIavXTj5J25z2O2HrG+AP0Ku7Voeno=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027