UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'K8HBqk9Z+AZInd2ewi8mCRD1x+NQXRH2Su+npe7M3Ao=' 
WHERE 
  key_id = '6cfc8cd47fbc6bb32d1f238c7a7fc6e75d6057028df984e598f793d86f6f7175' 
  AND (
    token = 'K8HBqk9Z+AZInd2ewi8mCRD1x+NQXRH2Su+npe7M3Ao=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023