UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YsL37DrzIY27BHFuz4hR5FPt/IENmyewyuZzrT2JCJA=' 
WHERE 
  key_id = '2a28c678268159c9848926ee12d19beb3ebed3ae6e466c88c0c559d1d21a386d' 
  AND (
    token = 'YsL37DrzIY27BHFuz4hR5FPt/IENmyewyuZzrT2JCJA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043