UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oHu0xgNuZqHrurh4bAVp3awGmIeA5+q2fMPk0zbvYV8=' 
WHERE 
  key_id = '7b0112023f1be1dd0b2d4d33014e54a6a2f5288be4ac963cf02ec44845a7b7c4' 
  AND (
    token = 'oHu0xgNuZqHrurh4bAVp3awGmIeA5+q2fMPk0zbvYV8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032