UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1VD/UAoI+AQM3uNg2P9a1b3U1s4MU6lNHBeznGSZ4Hk=' 
WHERE 
  key_id = '2c0f3455aaebaf095f867bbfcddf45f15d908a96c78e167b21c924f63a0ce9e8' 
  AND (
    token = '1VD/UAoI+AQM3uNg2P9a1b3U1s4MU6lNHBeznGSZ4Hk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029