UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wX6n3B77qMbaM3DZ1gWQSTeeCY1BLoMYlM8rPSaJkhs=' 
WHERE 
  key_id = 'ae27383a9a61df55afaa88d8081f2937ef1c3330ff31b94ec6f99339f291b746' 
  AND (
    token = 'wX6n3B77qMbaM3DZ1gWQSTeeCY1BLoMYlM8rPSaJkhs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00080